/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package general;

import conexion.CConexion;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 *
 * @author SISTEMAS
 */
public class CCo050 extends CConexion {

    public CCo050() {
        super();
    }
    
    public ResultSet traerRegistros(String cadena,String compania) throws SQLException {
        String sql = "select * from co050 where co050nocia = '" + compania + "'"+cadena;
        Statement stnc = this.getConexion().createStatement();
        ResultSet rs = stnc.executeQuery(sql);
        return rs;
    }
}
